package myJDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Locale;

import javax.sql.PooledConnection;

public class myConnection {
	public static Connection dbConnection = null;
    public static PooledConnection pool;
    
	public static void closeConnection() {
		try {
			dbConnection.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public static void setPool(PooledConnection poolCon)
			throws ClassNotFoundException {
	     pool = poolCon;
	}
	public static PooledConnection getPool() {
		return pool;
	}
	public static void Connect()
			throws ClassNotFoundException, SQLException {
		dbConnection = pool.getConnection();
	}
}
